{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts  \n",
    "import pandas as pd  \n",
    "from sqlalchemy import create_engine  \n",
    "import sqlalchemy\n",
    "import mysql.connector\n",
    "try:\n",
    "    conn = mysql.connector.connect(user='diagnose_report', password='launch@1234',\n",
    "                                   host='rm-wz9v9e07mh753tk321o.mysql.rds.aliyuncs.com',\n",
    "                                   database='car_spider')\n",
    "except mysql.connector.Error as err:\n",
    "    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:\n",
    "        print(\"Something is wrong with your user name or password\")\n",
    "    elif err.errno == errorcode.ER_BAD_DB_ERROR:\n",
    "        print(\"Database does not exist\")\n",
    "    else:\n",
    "        print(err)\n",
    "cursor = conn.cursor()\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_jc\")\n",
    "results = cursor.fetchall()\n",
    "jc = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_suv\")\n",
    "results = cursor.fetchall()\n",
    "suv = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "suv = suv.drop([8682,8723,8857,8858,9948,9949,10086,10202,10341,10342,10343,10361,10386])\n",
    "all1 = jc.append(suv)\n",
    "cursor.execute(\"select `factory`,`brand`,`style`,`style_1`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`engine_displacement`,`最大功率[kW]` from car_price_detail\")\n",
    "results = cursor.fetchall()\n",
    "price = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop\")\n",
    "results = cursor.fetchall()\n",
    "price2 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop_1\")\n",
    "results = cursor.fetchall()\n",
    "price3 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "price = price.append(price2)\n",
    "price = price.append(price3)\n",
    "conn.commit()\n",
    "cursor.close()\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = price[(price['brand']=='中华')|(price['brand']=='华颂')|(price['brand']=='金杯')]\n",
    "\n",
    "\n",
    "all1['3']=all1['vin'].apply(lambda x :x[:3])\n",
    "LSG = all1[(all1['3']=='LSY')]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand_x</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>3</th>\n",
       "      <th>轴距[mm]</th>\n",
       "      <th>长×宽×高[mm]</th>\n",
       "      <th>brand_y</th>\n",
       "      <th>style</th>\n",
       "      <th>factory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SY7150B4ZBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1365</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>110</td>\n",
       "      <td>LSYYBBCF×××××××××,LSYYBBDF×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SY7150B4ZBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1365</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>110</td>\n",
       "      <td>LSYYBBCF×××××××××,LSYYBBDF×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SY7150B4ZBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1365</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>110</td>\n",
       "      <td>LSYYBBCF×××××××××,LSYYBBDF×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SY7150B4ZBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1365</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>110</td>\n",
       "      <td>LSYYBBCF×××××××××,LSYYBBDF×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SY7150B4ZBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1365</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>110</td>\n",
       "      <td>LSYYBBCF×××××××××,LSYYBBDF×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>SY7150B4ZBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1365</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>110</td>\n",
       "      <td>LSYYBBCF×××××××××,LSYYBBDF×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>SY7150B2ZBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1325</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>82</td>\n",
       "      <td>LSYYBBCB×××××××××,LSYYBBDB×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>SY7150B2ZBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1325</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>82</td>\n",
       "      <td>LSYYBBCB×××××××××,LSYYBBDB×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>SY7150B2ZBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1325</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>82</td>\n",
       "      <td>LSYYBBCB×××××××××,LSYYBBDB×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>SY7150B2ZBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1325</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>82</td>\n",
       "      <td>LSYYBBCB×××××××××,LSYYBBDB×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>SY7150B2ZBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1325</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>82</td>\n",
       "      <td>LSYYBBCB×××××××××,LSYYBBDB×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>SY7150B2ZBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1325</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>82</td>\n",
       "      <td>LSYYBBCB×××××××××,LSYYBBDB×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>SY7150B2SBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1280</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>82</td>\n",
       "      <td>LSYYBACB×××××××××,LSYYBADB×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>SY7150B2SBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1280</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>82</td>\n",
       "      <td>LSYYBACB×××××××××,LSYYBADB×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>SY7150B2SBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1280</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>82</td>\n",
       "      <td>LSYYBACB×××××××××,LSYYBADB×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>SY7150B2SBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1280</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>82</td>\n",
       "      <td>LSYYBACB×××××××××,LSYYBADB×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>SY7150B2SBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1280</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>82</td>\n",
       "      <td>LSYYBACB×××××××××,LSYYBADB×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>SY7150B2SBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1280</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>82</td>\n",
       "      <td>LSYYBACB×××××××××,LSYYBADB×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>SY7150B4SBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1335</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>110</td>\n",
       "      <td>LSYYBACF×××××××××,LSYYBADF×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>SY7150B4SBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1335</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>110</td>\n",
       "      <td>LSYYBACF×××××××××,LSYYBADF×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>SY7150B4SBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1335</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>110</td>\n",
       "      <td>LSYYBACF×××××××××,LSYYBADF×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>SY7150B4SBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1335</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>110</td>\n",
       "      <td>LSYYBACF×××××××××,LSYYBADF×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>SY7150B4SBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1335</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>110</td>\n",
       "      <td>LSYYBACF×××××××××,LSYYBADF×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>SY7150B4SBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1335</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>110</td>\n",
       "      <td>LSYYBACF×××××××××,LSYYBADF×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640x1790x1445</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>SY7151E3ZBAE</td>\n",
       "      <td>中华</td>\n",
       "      <td>1214</td>\n",
       "      <td>2570</td>\n",
       "      <td>4390</td>\n",
       "      <td>1703</td>\n",
       "      <td>1482</td>\n",
       "      <td>1498</td>\n",
       "      <td>77</td>\n",
       "      <td>LSYYBBCA×××××××××,LSYYBBDA×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2570</td>\n",
       "      <td>4390x1703x1482</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H230</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>SY7152E3ZBAE</td>\n",
       "      <td>中华</td>\n",
       "      <td>1214</td>\n",
       "      <td>2570</td>\n",
       "      <td>4390</td>\n",
       "      <td>1703</td>\n",
       "      <td>1482</td>\n",
       "      <td>1498</td>\n",
       "      <td>77</td>\n",
       "      <td>LSYYBBCA×××××××××,LSYYBBDA×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2570</td>\n",
       "      <td>4390x1703x1482</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H230</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>SY7150E3ZBAE</td>\n",
       "      <td>中华</td>\n",
       "      <td>1214</td>\n",
       "      <td>2570</td>\n",
       "      <td>4390</td>\n",
       "      <td>1703</td>\n",
       "      <td>1482</td>\n",
       "      <td>1498</td>\n",
       "      <td>77</td>\n",
       "      <td>LSYYBBCA×××××××××,LSYYBBDA×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2570</td>\n",
       "      <td>4390x1703x1482</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H230</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>SY7152E3ZBAE</td>\n",
       "      <td>中华</td>\n",
       "      <td>1214</td>\n",
       "      <td>2570</td>\n",
       "      <td>4390</td>\n",
       "      <td>1703</td>\n",
       "      <td>1482</td>\n",
       "      <td>1498</td>\n",
       "      <td>77</td>\n",
       "      <td>LSYYBBAA×××××××××,LSYYBBBA×××××××××,LSYYBBCA××...</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2570</td>\n",
       "      <td>4390x1703x1482</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H230</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>SY7151E3ZBAE</td>\n",
       "      <td>中华</td>\n",
       "      <td>1214</td>\n",
       "      <td>2570</td>\n",
       "      <td>4390</td>\n",
       "      <td>1703</td>\n",
       "      <td>1482</td>\n",
       "      <td>1498</td>\n",
       "      <td>77</td>\n",
       "      <td>LSYYBBAA×××××××××,LSYYBBBA×××××××××,LSYYBBCA××...</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2570</td>\n",
       "      <td>4390x1703x1482</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H230</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>SY7150E3ZBAE</td>\n",
       "      <td>中华</td>\n",
       "      <td>1214</td>\n",
       "      <td>2570</td>\n",
       "      <td>4390</td>\n",
       "      <td>1703</td>\n",
       "      <td>1482</td>\n",
       "      <td>1498</td>\n",
       "      <td>77</td>\n",
       "      <td>LSYYBBAA×××××××××,LSYYBBBA×××××××××,LSYYBBCA××...</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2570</td>\n",
       "      <td>4390x1703x1482</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华H230</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>SY6513S1Z1BG</td>\n",
       "      <td>华颂</td>\n",
       "      <td>2050</td>\n",
       "      <td>3015</td>\n",
       "      <td>5104</td>\n",
       "      <td>1909</td>\n",
       "      <td>1935</td>\n",
       "      <td>1997</td>\n",
       "      <td>150</td>\n",
       "      <td>LSYAABCS×××××××××,LSYAABDS×××××××××</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>3015</td>\n",
       "      <td>5104x1909x1935</td>\n",
       "      <td>华颂</td>\n",
       "      <td>华颂7</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>SY6503S2Z1BG</td>\n",
       "      <td>华颂</td>\n",
       "      <td>2030</td>\n",
       "      <td>2990</td>\n",
       "      <td>5005</td>\n",
       "      <td>1909</td>\n",
       "      <td>1935</td>\n",
       "      <td>1997</td>\n",
       "      <td>178</td>\n",
       "      <td>LSYAABCU×××××××××,LSYAABDU×××××××××</td>\n",
       "      <td>华晨雷诺金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2990</td>\n",
       "      <td>5005x1909x1935</td>\n",
       "      <td>华颂</td>\n",
       "      <td>华颂7</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>SY6503S2Z1BG</td>\n",
       "      <td>华颂</td>\n",
       "      <td>2030</td>\n",
       "      <td>2990</td>\n",
       "      <td>5005</td>\n",
       "      <td>1909</td>\n",
       "      <td>1935</td>\n",
       "      <td>1997</td>\n",
       "      <td>178</td>\n",
       "      <td>LSYAABCU×××××××××,LSYAABDU×××××××××</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2990</td>\n",
       "      <td>5005x1909x1935</td>\n",
       "      <td>华颂</td>\n",
       "      <td>华颂7</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>261</th>\n",
       "      <td>SY6503S2Z1BG</td>\n",
       "      <td>华颂</td>\n",
       "      <td>2030</td>\n",
       "      <td>2990</td>\n",
       "      <td>5005</td>\n",
       "      <td>1909</td>\n",
       "      <td>1935</td>\n",
       "      <td>1997</td>\n",
       "      <td>178</td>\n",
       "      <td>LSYAABCU×××××××××,LSYAABDU×××××××××</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2990</td>\n",
       "      <td>5005x1909x1935</td>\n",
       "      <td>华颂</td>\n",
       "      <td>华颂7</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262</th>\n",
       "      <td>SY6503S2Z1BG</td>\n",
       "      <td>华颂</td>\n",
       "      <td>2030</td>\n",
       "      <td>2990</td>\n",
       "      <td>5005</td>\n",
       "      <td>1909</td>\n",
       "      <td>1935</td>\n",
       "      <td>1997</td>\n",
       "      <td>178</td>\n",
       "      <td>LSYAABCU×××××××××,LSYAABDU×××××××××</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2990</td>\n",
       "      <td>5005x1909x1935</td>\n",
       "      <td>华颂</td>\n",
       "      <td>华颂7</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263</th>\n",
       "      <td>SY6503S2Z1BG</td>\n",
       "      <td>华颂</td>\n",
       "      <td>2030</td>\n",
       "      <td>2990</td>\n",
       "      <td>5005</td>\n",
       "      <td>1909</td>\n",
       "      <td>1935</td>\n",
       "      <td>1997</td>\n",
       "      <td>178</td>\n",
       "      <td>LSYAABCU×××××××××,LSYAABDU×××××××××</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2990</td>\n",
       "      <td>5005x1909x1935</td>\n",
       "      <td>华颂</td>\n",
       "      <td>华颂7</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>264</th>\n",
       "      <td>SY6503S2Z1BG</td>\n",
       "      <td>华颂</td>\n",
       "      <td>2030</td>\n",
       "      <td>2990</td>\n",
       "      <td>5005</td>\n",
       "      <td>1909</td>\n",
       "      <td>1935</td>\n",
       "      <td>1997</td>\n",
       "      <td>178</td>\n",
       "      <td>LSYAABCU×××××××××,LSYAABDU×××××××××</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2990</td>\n",
       "      <td>5005x1909x1935</td>\n",
       "      <td>华颂</td>\n",
       "      <td>华颂7</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>265</th>\n",
       "      <td>SY6460F3SQ1BZ</td>\n",
       "      <td>中华</td>\n",
       "      <td>1580</td>\n",
       "      <td>2725</td>\n",
       "      <td>4620</td>\n",
       "      <td>1922</td>\n",
       "      <td>1734</td>\n",
       "      <td>1499</td>\n",
       "      <td>112</td>\n",
       "      <td>LSYWDACG×××××××××,LSYWDADG×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2725</td>\n",
       "      <td>4620x1922x1734</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华V6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>266</th>\n",
       "      <td>SY6460F3SQ1BZ</td>\n",
       "      <td>中华</td>\n",
       "      <td>1580</td>\n",
       "      <td>2725</td>\n",
       "      <td>4620</td>\n",
       "      <td>1922</td>\n",
       "      <td>1734</td>\n",
       "      <td>1499</td>\n",
       "      <td>112</td>\n",
       "      <td>LSYWDACG×××××××××,LSYWDADG×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2725</td>\n",
       "      <td>4620x1922x1734</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华V6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>267</th>\n",
       "      <td>SY6460F3SQ1BZ</td>\n",
       "      <td>中华</td>\n",
       "      <td>1580</td>\n",
       "      <td>2725</td>\n",
       "      <td>4620</td>\n",
       "      <td>1922</td>\n",
       "      <td>1734</td>\n",
       "      <td>1499</td>\n",
       "      <td>112</td>\n",
       "      <td>LSYWDACG×××××××××,LSYWDADG×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2725</td>\n",
       "      <td>4620x1922x1734</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华V6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>268</th>\n",
       "      <td>SY6460F3Z1BZ</td>\n",
       "      <td>中华</td>\n",
       "      <td>1550</td>\n",
       "      <td>2725</td>\n",
       "      <td>4620</td>\n",
       "      <td>1922</td>\n",
       "      <td>1727</td>\n",
       "      <td>1499</td>\n",
       "      <td>112</td>\n",
       "      <td>LSYWDBCG×××××××××,LSYWDBDG×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2725</td>\n",
       "      <td>4620x1922x1727</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华V6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>269</th>\n",
       "      <td>SY6460F3Z1BZ</td>\n",
       "      <td>中华</td>\n",
       "      <td>1550</td>\n",
       "      <td>2725</td>\n",
       "      <td>4620</td>\n",
       "      <td>1922</td>\n",
       "      <td>1727</td>\n",
       "      <td>1499</td>\n",
       "      <td>112</td>\n",
       "      <td>LSYWDBCG×××××××××,LSYWDBDG×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2725</td>\n",
       "      <td>4620x1922x1727</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华V6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270</th>\n",
       "      <td>SY6460F3ZQ1BZ</td>\n",
       "      <td>中华</td>\n",
       "      <td>1600</td>\n",
       "      <td>2725</td>\n",
       "      <td>4620</td>\n",
       "      <td>1922</td>\n",
       "      <td>1734</td>\n",
       "      <td>1499</td>\n",
       "      <td>112</td>\n",
       "      <td>LSYWDBCG×××××××××,LSYWDBDG×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2725</td>\n",
       "      <td>4620x1922x1734</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华V6</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271</th>\n",
       "      <td>SY6460F3ZQ1BZ</td>\n",
       "      <td>中华</td>\n",
       "      <td>1600</td>\n",
       "      <td>2725</td>\n",
       "      <td>4620</td>\n",
       "      <td>1922</td>\n",
       "      <td>1734</td>\n",
       "      <td>1499</td>\n",
       "      <td>112</td>\n",
       "      <td>LSYWDBCG×××××××××,LSYWDBDG×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2725</td>\n",
       "      <td>4620x1922x1734</td>\n",
       "      <td>中华</td>\n",
       "      <td>中华V6</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272</th>\n",
       "      <td>SY6470Q3SN</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1570</td>\n",
       "      <td>2725</td>\n",
       "      <td>4745</td>\n",
       "      <td>1856</td>\n",
       "      <td>1710</td>\n",
       "      <td>1495</td>\n",
       "      <td>113</td>\n",
       "      <td>LSYADACF×××××××××,LSYADADF×××××××××</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2725</td>\n",
       "      <td>4745x1856x1710</td>\n",
       "      <td>金杯</td>\n",
       "      <td>金杯S70</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273</th>\n",
       "      <td>SY6401X6ZBM</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1180</td>\n",
       "      <td>2500</td>\n",
       "      <td>4005</td>\n",
       "      <td>1725</td>\n",
       "      <td>1644</td>\n",
       "      <td>1495</td>\n",
       "      <td>75</td>\n",
       "      <td>LSYADBAA×××××××××,LSYADBBA×××××××××,LSYADBCA××...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2500</td>\n",
       "      <td>4005x1725x1644</td>\n",
       "      <td>金杯</td>\n",
       "      <td>智尚S30</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274</th>\n",
       "      <td>SY6401X6SBM</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1180</td>\n",
       "      <td>2500</td>\n",
       "      <td>4005</td>\n",
       "      <td>1725</td>\n",
       "      <td>1644</td>\n",
       "      <td>1495</td>\n",
       "      <td>75</td>\n",
       "      <td>LSYADAAA×××××××××,LSYADABA×××××××××,LSYADACA××...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2500</td>\n",
       "      <td>4005x1725x1644</td>\n",
       "      <td>金杯</td>\n",
       "      <td>智尚S30</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>275</th>\n",
       "      <td>SY6401X6ZBM</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1180</td>\n",
       "      <td>2500</td>\n",
       "      <td>4005</td>\n",
       "      <td>1725</td>\n",
       "      <td>1644</td>\n",
       "      <td>1495</td>\n",
       "      <td>75</td>\n",
       "      <td>LSYADBAA×××××××××,LSYADBBA×××××××××,LSYADBCA××...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2500</td>\n",
       "      <td>4005x1725x1644</td>\n",
       "      <td>金杯</td>\n",
       "      <td>智尚S30</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276</th>\n",
       "      <td>SY6401X6ZBM</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1180</td>\n",
       "      <td>2500</td>\n",
       "      <td>4005</td>\n",
       "      <td>1725</td>\n",
       "      <td>1644</td>\n",
       "      <td>1495</td>\n",
       "      <td>75</td>\n",
       "      <td>LSYADBAA×××××××××,LSYADBBA×××××××××,LSYADBCA××...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2500</td>\n",
       "      <td>4005x1725x1644</td>\n",
       "      <td>金杯</td>\n",
       "      <td>智尚S30</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277</th>\n",
       "      <td>SY6401X6SBM</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1180</td>\n",
       "      <td>2500</td>\n",
       "      <td>4005</td>\n",
       "      <td>1725</td>\n",
       "      <td>1644</td>\n",
       "      <td>1495</td>\n",
       "      <td>75</td>\n",
       "      <td>LSYADAAA×××××××××,LSYADABA×××××××××,LSYADACA××...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2500</td>\n",
       "      <td>4005x1725x1644</td>\n",
       "      <td>金杯</td>\n",
       "      <td>智尚S30</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278</th>\n",
       "      <td>SY6420C4SBW</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1140</td>\n",
       "      <td>2700</td>\n",
       "      <td>4200</td>\n",
       "      <td>1695</td>\n",
       "      <td>1930</td>\n",
       "      <td>1298</td>\n",
       "      <td>60</td>\n",
       "      <td>LSYAFAAM×××××××××</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2700</td>\n",
       "      <td>4200x1695x1930</td>\n",
       "      <td>金杯</td>\n",
       "      <td>金杯小海狮X30</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>SY6421C4SBW</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1140</td>\n",
       "      <td>2700</td>\n",
       "      <td>4200</td>\n",
       "      <td>1695</td>\n",
       "      <td>1930</td>\n",
       "      <td>1298</td>\n",
       "      <td>60</td>\n",
       "      <td>LSYAFAAM×××××××××</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2700</td>\n",
       "      <td>4200x1695x1930</td>\n",
       "      <td>金杯</td>\n",
       "      <td>金杯小海狮X30</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>280</th>\n",
       "      <td>SY6420C4SBW</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1140</td>\n",
       "      <td>2700</td>\n",
       "      <td>4200</td>\n",
       "      <td>1695</td>\n",
       "      <td>1930</td>\n",
       "      <td>1298</td>\n",
       "      <td>60</td>\n",
       "      <td>LSYAFAAM×××××××××</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2700</td>\n",
       "      <td>4200x1695x1930</td>\n",
       "      <td>金杯</td>\n",
       "      <td>金杯小海狮X30</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>281</th>\n",
       "      <td>SY6420C4SBW</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1140</td>\n",
       "      <td>2700</td>\n",
       "      <td>4200</td>\n",
       "      <td>1695</td>\n",
       "      <td>1930</td>\n",
       "      <td>1298</td>\n",
       "      <td>60</td>\n",
       "      <td>LSYAFAAM×××××××××</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2700</td>\n",
       "      <td>4200x1695x1930</td>\n",
       "      <td>金杯</td>\n",
       "      <td>金杯小海狮X30</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282</th>\n",
       "      <td>SY6420C4SBW</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1140</td>\n",
       "      <td>2700</td>\n",
       "      <td>4200</td>\n",
       "      <td>1695</td>\n",
       "      <td>1930</td>\n",
       "      <td>1298</td>\n",
       "      <td>60</td>\n",
       "      <td>LSYAFAAM×××××××××</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2700</td>\n",
       "      <td>4200x1695x1930</td>\n",
       "      <td>金杯</td>\n",
       "      <td>金杯小海狮X30</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>283</th>\n",
       "      <td>SY6470DS</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1900</td>\n",
       "      <td>2985</td>\n",
       "      <td>4715</td>\n",
       "      <td>1800</td>\n",
       "      <td>1970</td>\n",
       "      <td>2438</td>\n",
       "      <td>90</td>\n",
       "      <td>LSYBCAH8×××××××××\\r,LSYBSAH8×××××××××\\r,LSYAAA...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2985</td>\n",
       "      <td>4715x1800x1970</td>\n",
       "      <td>金杯</td>\n",
       "      <td>阁瑞斯</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284</th>\n",
       "      <td>SY6470EZ</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1900</td>\n",
       "      <td>2985</td>\n",
       "      <td>4715</td>\n",
       "      <td>1800</td>\n",
       "      <td>1970</td>\n",
       "      <td>2693</td>\n",
       "      <td>110</td>\n",
       "      <td>LSYBCBHJ×××××××××\\r,LSYBSBHJ×××××××××\\r,LSYAAB...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2985</td>\n",
       "      <td>4715x1800x1970</td>\n",
       "      <td>金杯</td>\n",
       "      <td>阁瑞斯</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285</th>\n",
       "      <td>SY6470KS</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1900</td>\n",
       "      <td>2985</td>\n",
       "      <td>4715</td>\n",
       "      <td>1800</td>\n",
       "      <td>1970</td>\n",
       "      <td>2438</td>\n",
       "      <td>102</td>\n",
       "      <td>LSYACABF×××××××××\\rLSYAAAAF×××××××××\\rLSYAAABF...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2985</td>\n",
       "      <td>4715x1800x1970</td>\n",
       "      <td>金杯</td>\n",
       "      <td>阁瑞斯</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286</th>\n",
       "      <td>SY6470KS</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1900</td>\n",
       "      <td>2985</td>\n",
       "      <td>4715</td>\n",
       "      <td>1800</td>\n",
       "      <td>1970</td>\n",
       "      <td>2438</td>\n",
       "      <td>102</td>\n",
       "      <td>LSYACABF×××××××××\\rLSYAAAAF×××××××××\\rLSYAAABF...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>2985</td>\n",
       "      <td>4715x1800x1970</td>\n",
       "      <td>金杯</td>\n",
       "      <td>阁瑞斯</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287</th>\n",
       "      <td>SY6521NS2</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1900</td>\n",
       "      <td>3430</td>\n",
       "      <td>5235</td>\n",
       "      <td>1800</td>\n",
       "      <td>1980</td>\n",
       "      <td>2237</td>\n",
       "      <td>76</td>\n",
       "      <td>LSYAAAAA××××××××× LSYAAABA××××××××× LSYAAACA××...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "      <td>3430</td>\n",
       "      <td>5235x1800x1980</td>\n",
       "      <td>金杯</td>\n",
       "      <td>阁瑞斯</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>288 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       notice_type brand_x curb_weight Wheelbase car_length car_width  \\\n",
       "0     SY7150B4ZBAH      中华        1365      2660       4640      1790   \n",
       "1     SY7150B4ZBAH      中华        1365      2660       4640      1790   \n",
       "2     SY7150B4ZBAH      中华        1365      2660       4640      1790   \n",
       "3     SY7150B4ZBAH      中华        1365      2660       4640      1790   \n",
       "4     SY7150B4ZBAH      中华        1365      2660       4640      1790   \n",
       "5     SY7150B4ZBAH      中华        1365      2660       4640      1790   \n",
       "6     SY7150B2ZBAH      中华        1325      2660       4640      1790   \n",
       "7     SY7150B2ZBAH      中华        1325      2660       4640      1790   \n",
       "8     SY7150B2ZBAH      中华        1325      2660       4640      1790   \n",
       "9     SY7150B2ZBAH      中华        1325      2660       4640      1790   \n",
       "10    SY7150B2ZBAH      中华        1325      2660       4640      1790   \n",
       "11    SY7150B2ZBAH      中华        1325      2660       4640      1790   \n",
       "12    SY7150B2SBAH      中华        1280      2660       4640      1790   \n",
       "13    SY7150B2SBAH      中华        1280      2660       4640      1790   \n",
       "14    SY7150B2SBAH      中华        1280      2660       4640      1790   \n",
       "15    SY7150B2SBAH      中华        1280      2660       4640      1790   \n",
       "16    SY7150B2SBAH      中华        1280      2660       4640      1790   \n",
       "17    SY7150B2SBAH      中华        1280      2660       4640      1790   \n",
       "18    SY7150B4SBAH      中华        1335      2660       4640      1790   \n",
       "19    SY7150B4SBAH      中华        1335      2660       4640      1790   \n",
       "20    SY7150B4SBAH      中华        1335      2660       4640      1790   \n",
       "21    SY7150B4SBAH      中华        1335      2660       4640      1790   \n",
       "22    SY7150B4SBAH      中华        1335      2660       4640      1790   \n",
       "23    SY7150B4SBAH      中华        1335      2660       4640      1790   \n",
       "24    SY7151E3ZBAE      中华        1214      2570       4390      1703   \n",
       "25    SY7152E3ZBAE      中华        1214      2570       4390      1703   \n",
       "26    SY7150E3ZBAE      中华        1214      2570       4390      1703   \n",
       "27    SY7152E3ZBAE      中华        1214      2570       4390      1703   \n",
       "28    SY7151E3ZBAE      中华        1214      2570       4390      1703   \n",
       "29    SY7150E3ZBAE      中华        1214      2570       4390      1703   \n",
       "..             ...     ...         ...       ...        ...       ...   \n",
       "258   SY6513S1Z1BG      华颂        2050      3015       5104      1909   \n",
       "259   SY6503S2Z1BG      华颂        2030      2990       5005      1909   \n",
       "260   SY6503S2Z1BG      华颂        2030      2990       5005      1909   \n",
       "261   SY6503S2Z1BG      华颂        2030      2990       5005      1909   \n",
       "262   SY6503S2Z1BG      华颂        2030      2990       5005      1909   \n",
       "263   SY6503S2Z1BG      华颂        2030      2990       5005      1909   \n",
       "264   SY6503S2Z1BG      华颂        2030      2990       5005      1909   \n",
       "265  SY6460F3SQ1BZ      中华        1580      2725       4620      1922   \n",
       "266  SY6460F3SQ1BZ      中华        1580      2725       4620      1922   \n",
       "267  SY6460F3SQ1BZ      中华        1580      2725       4620      1922   \n",
       "268   SY6460F3Z1BZ      中华        1550      2725       4620      1922   \n",
       "269   SY6460F3Z1BZ      中华        1550      2725       4620      1922   \n",
       "270  SY6460F3ZQ1BZ      中华        1600      2725       4620      1922   \n",
       "271  SY6460F3ZQ1BZ      中华        1600      2725       4620      1922   \n",
       "272     SY6470Q3SN      金杯        1570      2725       4745      1856   \n",
       "273    SY6401X6ZBM      金杯        1180      2500       4005      1725   \n",
       "274    SY6401X6SBM      金杯        1180      2500       4005      1725   \n",
       "275    SY6401X6ZBM      金杯        1180      2500       4005      1725   \n",
       "276    SY6401X6ZBM      金杯        1180      2500       4005      1725   \n",
       "277    SY6401X6SBM      金杯        1180      2500       4005      1725   \n",
       "278    SY6420C4SBW      金杯        1140      2700       4200      1695   \n",
       "279    SY6421C4SBW      金杯        1140      2700       4200      1695   \n",
       "280    SY6420C4SBW      金杯        1140      2700       4200      1695   \n",
       "281    SY6420C4SBW      金杯        1140      2700       4200      1695   \n",
       "282    SY6420C4SBW      金杯        1140      2700       4200      1695   \n",
       "283       SY6470DS      金杯        1900      2985       4715      1800   \n",
       "284       SY6470EZ      金杯        1900      2985       4715      1800   \n",
       "285       SY6470KS      金杯        1900      2985       4715      1800   \n",
       "286       SY6470KS      金杯        1900      2985       4715      1800   \n",
       "287      SY6521NS2      金杯        1900      3430       5235      1800   \n",
       "\n",
       "    car_height Displacement power  \\\n",
       "0         1445         1498   110   \n",
       "1         1445         1498   110   \n",
       "2         1445         1498   110   \n",
       "3         1445         1498   110   \n",
       "4         1445         1498   110   \n",
       "5         1445         1498   110   \n",
       "6         1445         1498    82   \n",
       "7         1445         1498    82   \n",
       "8         1445         1498    82   \n",
       "9         1445         1498    82   \n",
       "10        1445         1498    82   \n",
       "11        1445         1498    82   \n",
       "12        1445         1498    82   \n",
       "13        1445         1498    82   \n",
       "14        1445         1498    82   \n",
       "15        1445         1498    82   \n",
       "16        1445         1498    82   \n",
       "17        1445         1498    82   \n",
       "18        1445         1498   110   \n",
       "19        1445         1498   110   \n",
       "20        1445         1498   110   \n",
       "21        1445         1498   110   \n",
       "22        1445         1498   110   \n",
       "23        1445         1498   110   \n",
       "24        1482         1498    77   \n",
       "25        1482         1498    77   \n",
       "26        1482         1498    77   \n",
       "27        1482         1498    77   \n",
       "28        1482         1498    77   \n",
       "29        1482         1498    77   \n",
       "..         ...          ...   ...   \n",
       "258       1935         1997   150   \n",
       "259       1935         1997   178   \n",
       "260       1935         1997   178   \n",
       "261       1935         1997   178   \n",
       "262       1935         1997   178   \n",
       "263       1935         1997   178   \n",
       "264       1935         1997   178   \n",
       "265       1734         1499   112   \n",
       "266       1734         1499   112   \n",
       "267       1734         1499   112   \n",
       "268       1727         1499   112   \n",
       "269       1727         1499   112   \n",
       "270       1734         1499   112   \n",
       "271       1734         1499   112   \n",
       "272       1710         1495   113   \n",
       "273       1644         1495    75   \n",
       "274       1644         1495    75   \n",
       "275       1644         1495    75   \n",
       "276       1644         1495    75   \n",
       "277       1644         1495    75   \n",
       "278       1930         1298    60   \n",
       "279       1930         1298    60   \n",
       "280       1930         1298    60   \n",
       "281       1930         1298    60   \n",
       "282       1930         1298    60   \n",
       "283       1970         2438    90   \n",
       "284       1970         2693   110   \n",
       "285       1970         2438   102   \n",
       "286       1970         2438   102   \n",
       "287       1980         2237    76   \n",
       "\n",
       "                                                   vin   car_factory    3  \\\n",
       "0                  LSYYBBCF×××××××××,LSYYBBDF×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "1                  LSYYBBCF×××××××××,LSYYBBDF×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "2                  LSYYBBCF×××××××××,LSYYBBDF×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "3                  LSYYBBCF×××××××××,LSYYBBDF×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "4                  LSYYBBCF×××××××××,LSYYBBDF×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "5                  LSYYBBCF×××××××××,LSYYBBDF×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "6                  LSYYBBCB×××××××××,LSYYBBDB×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "7                  LSYYBBCB×××××××××,LSYYBBDB×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "8                  LSYYBBCB×××××××××,LSYYBBDB×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "9                  LSYYBBCB×××××××××,LSYYBBDB×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "10                 LSYYBBCB×××××××××,LSYYBBDB×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "11                 LSYYBBCB×××××××××,LSYYBBDB×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "12                 LSYYBACB×××××××××,LSYYBADB×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "13                 LSYYBACB×××××××××,LSYYBADB×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "14                 LSYYBACB×××××××××,LSYYBADB×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "15                 LSYYBACB×××××××××,LSYYBADB×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "16                 LSYYBACB×××××××××,LSYYBADB×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "17                 LSYYBACB×××××××××,LSYYBADB×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "18                 LSYYBACF×××××××××,LSYYBADF×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "19                 LSYYBACF×××××××××,LSYYBADF×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "20                 LSYYBACF×××××××××,LSYYBADF×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "21                 LSYYBACF×××××××××,LSYYBADF×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "22                 LSYYBACF×××××××××,LSYYBADF×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "23                 LSYYBACF×××××××××,LSYYBADF×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "24                 LSYYBBCA×××××××××,LSYYBBDA×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "25                 LSYYBBCA×××××××××,LSYYBBDA×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "26                 LSYYBBCA×××××××××,LSYYBBDA×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "27   LSYYBBAA×××××××××,LSYYBBBA×××××××××,LSYYBBCA××...  华晨汽车集团控股有限公司  LSY   \n",
       "28   LSYYBBAA×××××××××,LSYYBBBA×××××××××,LSYYBBCA××...  华晨汽车集团控股有限公司  LSY   \n",
       "29   LSYYBBAA×××××××××,LSYYBBBA×××××××××,LSYYBBCA××...  华晨汽车集团控股有限公司  LSY   \n",
       "..                                                 ...           ...  ...   \n",
       "258                LSYAABCS×××××××××,LSYAABDS×××××××××  沈阳华晨金杯汽车有限公司  LSY   \n",
       "259                LSYAABCU×××××××××,LSYAABDU×××××××××  华晨雷诺金杯汽车有限公司  LSY   \n",
       "260                LSYAABCU×××××××××,LSYAABDU×××××××××  沈阳华晨金杯汽车有限公司  LSY   \n",
       "261                LSYAABCU×××××××××,LSYAABDU×××××××××  沈阳华晨金杯汽车有限公司  LSY   \n",
       "262                LSYAABCU×××××××××,LSYAABDU×××××××××  沈阳华晨金杯汽车有限公司  LSY   \n",
       "263                LSYAABCU×××××××××,LSYAABDU×××××××××  沈阳华晨金杯汽车有限公司  LSY   \n",
       "264                LSYAABCU×××××××××,LSYAABDU×××××××××  沈阳华晨金杯汽车有限公司  LSY   \n",
       "265                LSYWDACG×××××××××,LSYWDADG×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "266                LSYWDACG×××××××××,LSYWDADG×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "267                LSYWDACG×××××××××,LSYWDADG×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "268                LSYWDBCG×××××××××,LSYWDBDG×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "269                LSYWDBCG×××××××××,LSYWDBDG×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "270                LSYWDBCG×××××××××,LSYWDBDG×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "271                LSYWDBCG×××××××××,LSYWDBDG×××××××××  华晨汽车集团控股有限公司  LSY   \n",
       "272                LSYADACF×××××××××,LSYADADF×××××××××  沈阳华晨金杯汽车有限公司  LSY   \n",
       "273  LSYADBAA×××××××××,LSYADBBA×××××××××,LSYADBCA××...  沈阳华晨金杯汽车有限公司  LSY   \n",
       "274  LSYADAAA×××××××××,LSYADABA×××××××××,LSYADACA××...  沈阳华晨金杯汽车有限公司  LSY   \n",
       "275  LSYADBAA×××××××××,LSYADBBA×××××××××,LSYADBCA××...  沈阳华晨金杯汽车有限公司  LSY   \n",
       "276  LSYADBAA×××××××××,LSYADBBA×××××××××,LSYADBCA××...  沈阳华晨金杯汽车有限公司  LSY   \n",
       "277  LSYADAAA×××××××××,LSYADABA×××××××××,LSYADACA××...  沈阳华晨金杯汽车有限公司  LSY   \n",
       "278                                  LSYAFAAM×××××××××  沈阳华晨金杯汽车有限公司  LSY   \n",
       "279                                  LSYAFAAM×××××××××  沈阳华晨金杯汽车有限公司  LSY   \n",
       "280                                  LSYAFAAM×××××××××  沈阳华晨金杯汽车有限公司  LSY   \n",
       "281                                  LSYAFAAM×××××××××  沈阳华晨金杯汽车有限公司  LSY   \n",
       "282                                  LSYAFAAM×××××××××  沈阳华晨金杯汽车有限公司  LSY   \n",
       "283  LSYBCAH8×××××××××\\r,LSYBSAH8×××××××××\\r,LSYAAA...  沈阳华晨金杯汽车有限公司  LSY   \n",
       "284  LSYBCBHJ×××××××××\\r,LSYBSBHJ×××××××××\\r,LSYAAB...  沈阳华晨金杯汽车有限公司  LSY   \n",
       "285  LSYACABF×××××××××\\rLSYAAAAF×××××××××\\rLSYAAABF...  沈阳华晨金杯汽车有限公司  LSY   \n",
       "286  LSYACABF×××××××××\\rLSYAAAAF×××××××××\\rLSYAAABF...  沈阳华晨金杯汽车有限公司  LSY   \n",
       "287  LSYAAAAA××××××××× LSYAAABA××××××××× LSYAAACA××...  沈阳华晨金杯汽车有限公司  LSY   \n",
       "\n",
       "    轴距[mm]       长×宽×高[mm] brand_y     style  factory  \n",
       "0     2660  4640x1790x1445      中华      中华H3        1  \n",
       "1     2660  4640x1790x1445      中华      中华H3        1  \n",
       "2     2660  4640x1790x1445      中华      中华H3        1  \n",
       "3     2660  4640x1790x1445      中华      中华H3        1  \n",
       "4     2660  4640x1790x1445      中华      中华H3        1  \n",
       "5     2660  4640x1790x1445      中华      中华H3        1  \n",
       "6     2660  4640x1790x1445      中华      中华H3        2  \n",
       "7     2660  4640x1790x1445      中华      中华H3        2  \n",
       "8     2660  4640x1790x1445      中华      中华H3        2  \n",
       "9     2660  4640x1790x1445      中华      中华H3        2  \n",
       "10    2660  4640x1790x1445      中华      中华H3        2  \n",
       "11    2660  4640x1790x1445      中华      中华H3        2  \n",
       "12    2660  4640x1790x1445      中华      中华H3        2  \n",
       "13    2660  4640x1790x1445      中华      中华H3        2  \n",
       "14    2660  4640x1790x1445      中华      中华H3        2  \n",
       "15    2660  4640x1790x1445      中华      中华H3        2  \n",
       "16    2660  4640x1790x1445      中华      中华H3        2  \n",
       "17    2660  4640x1790x1445      中华      中华H3        2  \n",
       "18    2660  4640x1790x1445      中华      中华H3        1  \n",
       "19    2660  4640x1790x1445      中华      中华H3        1  \n",
       "20    2660  4640x1790x1445      中华      中华H3        1  \n",
       "21    2660  4640x1790x1445      中华      中华H3        1  \n",
       "22    2660  4640x1790x1445      中华      中华H3        1  \n",
       "23    2660  4640x1790x1445      中华      中华H3        1  \n",
       "24    2570  4390x1703x1482      中华    中华H230        2  \n",
       "25    2570  4390x1703x1482      中华    中华H230        2  \n",
       "26    2570  4390x1703x1482      中华    中华H230        2  \n",
       "27    2570  4390x1703x1482      中华    中华H230        2  \n",
       "28    2570  4390x1703x1482      中华    中华H230        2  \n",
       "29    2570  4390x1703x1482      中华    中华H230        2  \n",
       "..     ...             ...     ...       ...      ...  \n",
       "258   3015  5104x1909x1935      华颂       华颂7        2  \n",
       "259   2990  5005x1909x1935      华颂       华颂7        3  \n",
       "260   2990  5005x1909x1935      华颂       华颂7        3  \n",
       "261   2990  5005x1909x1935      华颂       华颂7        3  \n",
       "262   2990  5005x1909x1935      华颂       华颂7        3  \n",
       "263   2990  5005x1909x1935      华颂       华颂7        3  \n",
       "264   2990  5005x1909x1935      华颂       华颂7        3  \n",
       "265   2725  4620x1922x1734      中华      中华V6        1  \n",
       "266   2725  4620x1922x1734      中华      中华V6        1  \n",
       "267   2725  4620x1922x1734      中华      中华V6        1  \n",
       "268   2725  4620x1922x1727      中华      中华V6        2  \n",
       "269   2725  4620x1922x1727      中华      中华V6        2  \n",
       "270   2725  4620x1922x1734      中华      中华V6        3  \n",
       "271   2725  4620x1922x1734      中华      中华V6        3  \n",
       "272   2725  4745x1856x1710      金杯     金杯S70        5  \n",
       "273   2500  4005x1725x1644      金杯     智尚S30       12  \n",
       "274   2500  4005x1725x1644      金杯     智尚S30       12  \n",
       "275   2500  4005x1725x1644      金杯     智尚S30       12  \n",
       "276   2500  4005x1725x1644      金杯     智尚S30       12  \n",
       "277   2500  4005x1725x1644      金杯     智尚S30       12  \n",
       "278   2700  4200x1695x1930      金杯  金杯小海狮X30        8  \n",
       "279   2700  4200x1695x1930      金杯  金杯小海狮X30        8  \n",
       "280   2700  4200x1695x1930      金杯  金杯小海狮X30        8  \n",
       "281   2700  4200x1695x1930      金杯  金杯小海狮X30        8  \n",
       "282   2700  4200x1695x1930      金杯  金杯小海狮X30        8  \n",
       "283   2985  4715x1800x1970      金杯       阁瑞斯        1  \n",
       "284   2985  4715x1800x1970      金杯       阁瑞斯        1  \n",
       "285   2985  4715x1800x1970      金杯       阁瑞斯        1  \n",
       "286   2985  4715x1800x1970      金杯       阁瑞斯        1  \n",
       "287   3430  5235x1800x1980      金杯       阁瑞斯        6  \n",
       "\n",
       "[288 rows x 17 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price = LSG_price[(LSG_price['长×宽×高[mm]']!='')]\n",
    "LSG_price['curb_weight'] =LSG_price['整备质量[kg]']\n",
    "LSG_price = LSG_price.groupby(['轴距[mm]','长×宽×高[mm]','brand','style','curb_weight'])['factory'].count().reset_index()\n",
    "LSG_price['car_length'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[0])\n",
    "LSG_price['car_width'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[1])\n",
    "LSG_price['car_height'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[2])\n",
    "LSG_price['Wheelbase'] =LSG_price['轴距[mm]']\n",
    "\n",
    "LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height','curb_weight'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])\n",
    "import re\n",
    "vin1 = []\n",
    "for a,i in result.iterrows():\n",
    "    a = re.findall(r'L[0-9A-Za-z]{7}×××××××××',i['vin'])\n",
    "    for j in a:\n",
    "        vin = []\n",
    "        vin.append(j)\n",
    "        vin.append(i['car_factory'].split(',')[0])\n",
    "        vin.append(i['brand_y'].split(',')[0])\n",
    "        vin.append(i['style'].split(',')[0])\n",
    "        vin1.append(vin)\n",
    "vin = pd.DataFrame(vin1,columns=['vin','car_factory','brand','style'])\n",
    "vin = vin.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "vin.to_csv('中华_华颂_金杯_VIN.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
